<!-- 1903010328 查询通行证 -->
<?php
include "../../inc/log/adsession.php";
// include "../../inc/data/connAdmin.php";
?>
<!doctype html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>学生管理首页</title>
	<link rel="stylesheet" type="text/css" href="/28/inc/CSS/admin">
	<link rel="stylesheet" type="text/css" href="/28/inc/CSS/reset.css">
	<script type="text/javascript" src="../ajaxPhp/ajaxcourse.js"></script>
</head>
<body>
	<div id="tScoreln">
		<!--顶部-->
			<div id="top">
			<img src="/28/inc/pic/00.png">
			<!--导航栏区域和下拉列表-->
			<div id="top-rig">
			<ul>
			    <li><a href="">首页</a></li>
			    <li id="ddown"><a href="" id="dropbtn">学校概况</a>
				    <div id="ddown-content">
				    <a href="">学校简介</a>
				    <a href="">历任教师</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">国际合作</a>
				    <div id="ddown-content">
				    <a href="">交流概况</a>
				    <a href="">国际学生</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">院系部门</a>
				    <div id="ddown-content">
				    <a href="">党群机构</a>
				    <a href="">管理与服务机构</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">科学研究</a>
				    <div id="ddown-content">
				    <a href="">科研概况</a>
				    <a href="">重点学科</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">教师队伍</a>
				    <div id="ddown-content">
				    <a href="">总体介绍</a>
				    <a href="">杰出人才</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">人才培养</a>
				    <div id="ddown-content">
				    <a href="">继续教育</a>
				    <a href="">奖贷学金</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">人才招聘</a>
				    <div id="ddown-content">
				    <a href="">优秀博士后</a>
				    <a href="">应聘方式</a>
				    </div>
				</li>
                <li id="ddown"><a href="" id="dropbtn">招生就业</a>
				    <div id="ddown-content">
				    <a href="">本科生招生</a>
				    <a href="">就业服务</a>
				    </div>
				</li>
				<img src="/28/inc/pic/find1.png">
		    </ul>
			</div>
			</div>
	    <!--顶部结束-->
	    <!---->
	    	<div id="main">
	        	<img src="/28/inc/pic/position.png">
	    		当前位置: 后台首页-课程管理
	    <!--结束-->
	    <div id="yh">
	    <img src="/28/inc/pic/user.png" style="width:25px;height:25px;margin:3px 10px;">
		<!-- 1903010328 动态信息 -->
		<h4 style="margin:8px 10px;font-size:20px;color:#1D50A2">您好！
		<?=$_SESSION["uName"]?>
		</h4>
	    </div>
	    <div id="SZ" style="">
	    	<ul style="font-size:20px;">
	    	<li id="" style="">
				<a href="../admin.php">后台首页</a></li>
				<li id="" style="">
				<a href="/28/admin/menu/menuAdmin.php">菜单管理</a></li>
				<li id="" style="">
				<a href="/28/admin/dep/depAdmin.php">二级学院管理</a></li>
				<li id="" style="">
				<a href="">教师管理</a></li>
				<li id="" style="">
				<a href="/28/admin/stu/stuAdmin.php">学生管理</a></li>
				<li id="" style="">
				<a href="/28/admin/cou/courseAdmin.php">课程管理</a></li>
				<li id="" style="">
				<a href="/28/admin/course/taskAdmin.php">教学任务管理</a></li>
				<li id="" style="">
				<a href="/28/admin/adminQuit.php">注销</a></li>
				<li id="" style="">
				<a href="depAdd.php"><input type="button" value="添加二级学院" name="depname" style="width:100px;height:25px;background-color:#1eca1c;color:white"></a></li>
			</ul>
	    </div>
		<!--结束-->
	    <!--表格区域-->
	
		<?php
			include "../../inc/data/connAdmin.php";
			$sql_dep = "select depname from mamx_dep";
			if ($stmtDep = $conn->prepare($sql_dep))
  			{
		  	$stmtDep->bind_result($depName);
		  	$stmtDep->execute();
		  	$stmtDep->store_result();
		  	}
			$sql_ma = "select majorname from mamx_major";
			if ($stmtMa = $conn->prepare($sql_ma)){
		 		$stmtMa->bind_result($majorName);
		  		$stmtMa->execute();
		  		$stmtMa->store_result();}
		?>
		<!-- 1903010328导入区域 -->

	<form action="couExImport.php" enctype="multipart/form-data" method="post" style="" >
  		<table  style="margin: 10px auto;border:4px solid #1D50A2" width="400px">
  			<tr>
				<td style="width:300px">
     				<input type="file" value="选择文件" name="coufile" style="width:300px;height:30px">
      			</td>
      			<td>
      				<input type="hidden"  name='classname'>
      				<input type="submit"  value="录入" style="width:100px;height:30px;background-color:#1D50A2;font-size:20px;text-align:center;color:white">
      			</td>
      		</tr>
  			<tr>
    			<td colspan="2" style="text-align:center">
   				<a href="../../inc/download/majorDown.xlsx"><input type="submit" value="下载模板" style="width:100px;height:30px;background-color:#1da252;font-size:20px;text-align:center;color:white"></a>
    			</td>
  			</tr>
  		</table>
	</form>
		<!-- 查询 -->
	<div class="">
		<form action=""  method="post" name="course"<form action=""  method="post" name="course">
			<table style="width:70%;margin:20px auto;text-align:center;border:4px solid #1D50A2;font-size:20px;font-weight:600;">
				<tr>
				<td colspan="2">
					<h3>查询课程</h3>
				</td></tr>
				<tr>
      			<td colspan="2" style="color:#1D50A2">
       				学期:
       				<select name="coterm" id="" style="height:28px;font-size:20px;margin:auto 10px;color:#1da252;">
			            <option value="1">1</option>
			            <option value="2">2</option>
			            <option value="3">3</option>
			            <option value="4">4</option>
			        </select>
        			二级学院:
        			<select name="depname"  style="height:28px;font-size:20px;margin:auto 10px;color:#1da252">
          				<option value="">请选择学院</option> 
           			<?php               
                		if ($stmtDep->num_rows > 0) {
                  			while($stmtDep->fetch()){
                    		echo <<<END
                    		<option value="$depName">$depName</option>
END;
                  		}}
                		else{
                  			echo <<<END
                  			<option value="">暂无记录</option>
END;
                			}
              				?>
        			</select>
        			<input type="button" value="查询" style="width:100px;height:28px;background-color:#1D50A2;font-size:18px;text-align:center;color:white">
  				</td>
			</tr>
			<tr>
  				<td  style="color:#1D50A2">
  				按专业查询>>>专业：
     			<select name="major"  style="height:28px;font-size:20px;margin:auto 10px;color:#1da252">
           		<?php               
                	if ($stmtMa->num_rows > 0) {
                  	while($stmtMa->fetch()){
                    	echo <<<END
                    	<option value="$majorName">$majorName</option>
END;
                  		}
                	}
                	else{
                 	    echo <<<END
                  		<option value="">暂无记录</option>
END;
                		}
              	?>
        		</select>
        		<!-- 1903010328 查询条件为学期和专业 -->
        		<input type="button" value="查询" onclick="showCou(document.course.coterm.value+''+ document.course.major.value);" style="width:100px;height:28px;background-color:#1D50A2;font-size:18px;text-align:center;color:white">
			    </td>
			</tr>
			<tr>
				<td  style="color:#7c5429">
       	 		<input  type="submit" value="退出EXCEL"  style="width:100px;height:28px;background-color:#1da252;font-size:18px;text-align:center;color:white">点击导出EXCEL没有反应，请先关掉上网助手或者按住ctrl键点击按钮
				</td>
			</tr>			
		</table>
		</form>
		<!-- 1903010328 成绩信息显示 -->
		<div id="couShow"></div>
	</div>
		
	</div>
</body>
</html>